Overview

Dataset statistics

Number of variables178
Number of observations741
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory210.0 KiB
Average record size in memory290.2 B

Variable types

BOOL172
NUM6

Reproduction

Analysis started2020-06-21 11:01:04.941106
Analysis finished2020-06-21 11:02:39.255042
Duration1 minute and 34.31 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

Sector_Accounting & Legal is highly correlated with Industry_AccountingHigh correlation
Industry_Accounting is highly correlated with Sector_Accounting & LegalHigh correlation
Sector_Aerospace & Defense is highly correlated with Industry_Aerospace & DefenseHigh correlation
Industry_Aerospace & Defense is highly correlated with Sector_Aerospace & DefenseHigh correlation
Sector_Agriculture & Forestry is highly correlated with Industry_Farm Support ServicesHigh correlation
Industry_Farm Support Services is highly correlated with Sector_Agriculture & ForestryHigh correlation
Sector_Arts, Entertainment & Recreation is highly correlated with Industry_GamblingHigh correlation
Industry_Gambling is highly correlated with Sector_Arts, Entertainment & RecreationHigh correlation
Sector_Biotech & Pharmaceuticals is highly correlated with Industry_Biotech & PharmaceuticalsHigh correlation
Industry_Biotech & Pharmaceuticals is highly correlated with Sector_Biotech & PharmaceuticalsHigh correlation
Sector_Construction, Repair & Maintenance is highly correlated with Industry_ConstructionHigh correlation
Industry_Construction is highly correlated with Sector_Construction, Repair & MaintenanceHigh correlation
Sector_Government is highly correlated with Industry_Federal AgenciesHigh correlation
Industry_Federal Agencies is highly correlated with Sector_GovernmentHigh correlation
Sector_Health is highly correlated with Industry_HealthHigh correlation
Industry_Health is highly correlated with Sector_HealthHigh correlation
Sector_Health Care is highly correlated with Industry_Health Care Services & HospitalsHigh correlation
Industry_Health Care Services & Hospitals is highly correlated with Sector_Health CareHigh correlation
Sector_Insurance is highly correlated with Industry_Insurance CarriersHigh correlation
Industry_Insurance Carriers is highly correlated with Sector_InsuranceHigh correlation
Sector_Oil, Gas, Energy & Utilities is highly correlated with Industry_EnergyHigh correlation
Industry_Energy is highly correlated with Sector_Oil, Gas, Energy & UtilitiesHigh correlation
Sector_Real Estate is highly correlated with Industry_Real EstateHigh correlation
Industry_Real Estate is highly correlated with Sector_Real EstateHigh correlation
Sector_Travel & Tourism is highly correlated with Industry_Travel AgenciesHigh correlation
Industry_Travel Agencies is highly correlated with Sector_Travel & TourismHigh correlation
job_state_KS is highly correlated with Industry_Stock ExchangesHigh correlation
Industry_Stock Exchanges is highly correlated with job_state_KSHigh correlation
df_index has unique values Unique
comp has 459 (61.9%) zeros Zeros

Variables

df_index
Real number (ℝ≥0)

UNIQUE

Distinct count741
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean370.2159244264507
Minimum0
Maximum741
Zeros1
Zeros (%)0.1%
Memory size5.8 KiB

Quantile statistics

Minimum0
5-th percentile37
Q1185
median370
Q3555
95-th percentile704
Maximum741
Range741
Interquartile range (IQR)370

Descriptive statistics

Standard deviation214.3461946
Coefficient of variation (CV)0.5789761609
Kurtosis-1.198978966
Mean370.2159244
Median Absolute Deviation (MAD)185
Skewness0.002703331065
Sum274330
Variance45944.29115
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
74110.1%
 
24210.1%
 
25110.1%
 
25010.1%
 
24910.1%
 
24810.1%
 
24710.1%
 
24610.1%
 
24510.1%
 
24410.1%
 
Other values (731)73198.7%
 
ValueCountFrequency (%) 
010.1%
 
110.1%
 
210.1%
 
310.1%
 
410.1%
 
ValueCountFrequency (%) 
74110.1%
 
74010.1%
 
73910.1%
 
73810.1%
 
73710.1%
 

Rating
Real number (ℝ≥0)

Distinct count30
Unique (%)4.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.688529014844804
Minimum1.9
Maximum5.0
Zeros0
Zeros (%)0.0%
Memory size5.8 KiB

Quantile statistics

Minimum1.9
5-th percentile2.7
Q13.3
median3.7
Q34
95-th percentile4.7
Maximum5
Range3.1
Interquartile range (IQR)0.7

Descriptive statistics

Standard deviation0.5664881104
Coefficient of variation (CV)0.1535810368
Kurtosis0.1816476944
Mean3.688529015
Median Absolute Deviation (MAD)0.3
Skewness-0.2647969148
Sum2733.2
Variance0.3209087792
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
3.7719.6%
 
3.9638.5%
 
3.8618.2%
 
3.5496.6%
 
4476.3%
 
3.6466.2%
 
3.4445.9%
 
3.3395.3%
 
3.2354.7%
 
4.4334.5%
 
Other values (20)25334.1%
 
ValueCountFrequency (%) 
1.930.4%
 
2.150.7%
 
2.220.3%
 
2.320.3%
 
2.470.9%
 
ValueCountFrequency (%) 
550.7%
 
4.891.2%
 
4.7314.2%
 
4.6101.3%
 
4.570.9%
 

avg_salary
Real number (ℝ≥0)

Distinct count219
Unique (%)29.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean101.41295546558705
Minimum15.5
Maximum254.0
Zeros0
Zeros (%)0.0%
Memory size5.8 KiB

Quantile statistics

Minimum15.5
5-th percentile50
Q173.5
median97.5
Q3122.5
95-th percentile167.5
Maximum254
Range238.5
Interquartile range (IQR)49

Descriptive statistics

Standard deviation37.56683478
Coefficient of variation (CV)0.3704342764
Kurtosis0.9748108543
Mean101.4129555
Median Absolute Deviation (MAD)24.5
Skewness0.7909752104
Sum75147
Variance1411.267075
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
87.5121.6%
 
81111.5%
 
140111.5%
 
84.5101.3%
 
107.5101.3%
 
107101.3%
 
85101.3%
 
8791.2%
 
12091.2%
 
154.581.1%
 
Other values (209)64186.5%
 
ValueCountFrequency (%) 
15.510.1%
 
2720.3%
 
29.510.1%
 
37.520.3%
 
39.510.1%
 
ValueCountFrequency (%) 
25430.4%
 
237.510.1%
 
232.510.1%
 
22520.3%
 
221.510.1%
 

hourly
Boolean

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
0
717
1
 
24
ValueCountFrequency (%) 
071796.8%
 
1243.2%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
0
725
1
 
16
ValueCountFrequency (%) 
072597.8%
 
1162.2%
 

same_state
Boolean

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
1
414
0
327
ValueCountFrequency (%) 
141455.9%
 
032744.1%
 

age
Real number (ℝ≥0)

Distinct count102
Unique (%)13.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean49.807203308801434
Minimum1.0
Maximum276.0
Zeros0
Zeros (%)0.0%
Memory size5.8 KiB

Quantile statistics

Minimum1
5-th percentile6
Q113
median32
Q359
95-th percentile169
Maximum276
Range275
Interquartile range (IQR)46

Descriptive statistics

Standard deviation52.27501901
Coefficient of variation (CV)1.049547365
Kurtosis2.978707969
Mean49.80720331
Median Absolute Deviation (MAD)20
Skewness1.813772571
Sum36907.13765
Variance2732.677613
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
46.65587045496.6%
 
10324.3%
 
12314.2%
 
24273.6%
 
14243.2%
 
8212.8%
 
9192.6%
 
36182.4%
 
18182.4%
 
62182.4%
 
Other values (92)48465.3%
 
ValueCountFrequency (%) 
120.3%
 
3121.6%
 
450.7%
 
5162.2%
 
6131.8%
 
ValueCountFrequency (%) 
27610.1%
 
239141.9%
 
20810.1%
 
19040.5%
 
17420.3%
 

python
Boolean

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
1
392
0
349
ValueCountFrequency (%) 
139252.9%
 
034947.1%
 

sas
Boolean

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
0
654
1
 
87
ValueCountFrequency (%) 
065488.3%
 
18711.7%
 

spark
Boolean

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
0
574
1
167
ValueCountFrequency (%) 
057477.5%
 
116722.5%
 

aws
Boolean

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
0
565
1
176
ValueCountFrequency (%) 
056576.2%
 
117623.8%
 

sql
Boolean

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
1
380
0
361
ValueCountFrequency (%) 
138051.3%
 
036148.7%
 

excel
Boolean

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
1
387
0
354
ValueCountFrequency (%) 
138752.2%
 
035447.8%
 

matlab
Boolean

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
0
686
1
 
55
ValueCountFrequency (%) 
068692.6%
 
1557.4%
 

desc_len
Real number (ℝ≥0)

Distinct count439
Unique (%)59.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3910.773279352227
Minimum407
Maximum10146
Zeros0
Zeros (%)0.0%
Memory size5.8 KiB

Quantile statistics

Minimum407
5-th percentile1808
Q12834
median3782
Q34772
95-th percentile6683
Maximum10146
Range9739
Interquartile range (IQR)1938

Descriptive statistics

Standard deviation1534.776435
Coefficient of variation (CV)0.3924483281
Kurtosis1.055770248
Mean3910.773279
Median Absolute Deviation (MAD)985
Skewness0.7678333868
Sum2897883
Variance2355538.705
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
453850.7%
 
333440.5%
 
285540.5%
 
542140.5%
 
231240.5%
 
196740.5%
 
464440.5%
 
245540.5%
 
390140.5%
 
521540.5%
 
Other values (429)70094.5%
 
ValueCountFrequency (%) 
40710.1%
 
69510.1%
 
71410.1%
 
74510.1%
 
88910.1%
 
ValueCountFrequency (%) 
1014620.3%
 
934710.1%
 
916520.3%
 
888220.3%
 
887620.3%
 

comp
Real number (ℝ≥0)

ZEROS

Distinct count5
Unique (%)0.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.0553306342780027
Minimum0
Maximum4
Zeros459
Zeros (%)61.9%
Memory size5.8 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q33
95-th percentile3
Maximum4
Range4
Interquartile range (IQR)3

Descriptive statistics

Standard deviation1.384631595
Coefficient of variation (CV)1.312035821
Kurtosis-1.552646479
Mean1.055330634
Median Absolute Deviation (MAD)0
Skewness0.6111813388
Sum782
Variance1.917204654
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
045961.9%
 
322830.8%
 
2415.5%
 
1121.6%
 
410.1%
 
ValueCountFrequency (%) 
045961.9%
 
1121.6%
 
2415.5%
 
322830.8%
 
410.1%
 
ValueCountFrequency (%) 
410.1%
 
322830.8%
 
2415.5%
 
1121.6%
 
045961.9%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
710
1
 
31
ValueCountFrequency (%) 
071095.8%
 
1314.2%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
611
1
130
ValueCountFrequency (%) 
061182.5%
 
113017.5%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
591
1
150
ValueCountFrequency (%) 
059179.8%
 
115020.2%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
624
1
 
117
ValueCountFrequency (%) 
062484.2%
 
111715.8%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
665
1
 
76
ValueCountFrequency (%) 
066589.7%
 
17610.3%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
607
1
134
ValueCountFrequency (%) 
060781.9%
 
113418.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
647
1
 
94
ValueCountFrequency (%) 
064787.3%
 
19412.7%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
732
1
 
9
ValueCountFrequency (%) 
073298.8%
 
191.2%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
728
1
 
13
ValueCountFrequency (%) 
072898.2%
 
1131.8%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
1
410
0
331
ValueCountFrequency (%) 
141055.3%
 
033144.7%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
548
1
193
ValueCountFrequency (%) 
054874.0%
 
119326.0%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
726
1
 
15
ValueCountFrequency (%) 
072698.0%
 
1152.0%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
726
1
 
15
ValueCountFrequency (%) 
072698.0%
 
1152.0%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
686
1
 
55
ValueCountFrequency (%) 
068692.6%
 
1557.4%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
738
1
 
3
ValueCountFrequency (%) 
073899.6%
 
130.4%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
739
1
 
2
ValueCountFrequency (%) 
073999.7%
 
120.3%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
707
1
 
34
ValueCountFrequency (%) 
070795.4%
 
1344.6%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
740
1
 
1
ValueCountFrequency (%) 
074099.9%
 
110.1%
 

Industry_Accounting
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
740
1
 
1
ValueCountFrequency (%) 
074099.9%
 
110.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
716
1
 
25
ValueCountFrequency (%) 
071696.6%
 
1253.4%
 

Industry_Aerospace & Defense
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
716
1
 
25
ValueCountFrequency (%) 
071696.6%
 
1253.4%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
737
1
 
4
ValueCountFrequency (%) 
073799.5%
 
140.5%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
740
1
 
1
ValueCountFrequency (%) 
074099.9%
 
110.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
729
1
 
12
ValueCountFrequency (%) 
072998.4%
 
1121.6%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
740
1
 
1
ValueCountFrequency (%) 
074099.9%
 
110.1%
 

Industry_Biotech & Pharmaceuticals
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
629
1
 
112
ValueCountFrequency (%) 
062984.9%
 
111215.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
739
1
 
2
ValueCountFrequency (%) 
073999.7%
 
120.3%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
725
1
 
16
ValueCountFrequency (%) 
072597.8%
 
1162.2%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
682
1
 
59
ValueCountFrequency (%) 
068292.0%
 
1598.0%
 

Industry_Construction
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
738
1
 
3
ValueCountFrequency (%) 
073899.6%
 
130.4%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
712
1
 
29
ValueCountFrequency (%) 
071296.1%
 
1293.9%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
738
1
 
3
ValueCountFrequency (%) 
073899.6%
 
130.4%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
721
1
 
20
ValueCountFrequency (%) 
072197.3%
 
1202.7%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
735
1
 
6
ValueCountFrequency (%) 
073599.2%
 
160.8%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
738
1
 
3
ValueCountFrequency (%) 
073899.6%
 
130.4%
 

Industry_Energy
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
727
1
 
14
ValueCountFrequency (%) 
072798.1%
 
1141.9%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
699
1
 
42
ValueCountFrequency (%) 
069994.3%
 
1425.7%
 

Industry_Farm Support Services
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
740
1
 
1
ValueCountFrequency (%) 
074099.9%
 
110.1%
 

Industry_Federal Agencies
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
730
1
 
11
ValueCountFrequency (%) 
073098.5%
 
1111.5%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
733
1
 
8
ValueCountFrequency (%) 
073398.9%
 
181.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
737
1
 
4
ValueCountFrequency (%) 
073799.5%
 
140.5%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
733
1
 
8
ValueCountFrequency (%) 
073398.9%
 
181.1%
 

Industry_Gambling
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
737
1
 
4
ValueCountFrequency (%) 
073799.5%
 
140.5%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
737
1
 
4
ValueCountFrequency (%) 
073799.5%
 
140.5%
 

Industry_Health
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
732
1
 
9
ValueCountFrequency (%) 
073298.8%
 
191.2%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
740
1
 
1
ValueCountFrequency (%) 
074099.9%
 
110.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
692
1
 
49
ValueCountFrequency (%) 
069293.4%
 
1496.6%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
740
1
 
1
ValueCountFrequency (%) 
074099.9%
 
110.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
691
1
 
50
ValueCountFrequency (%) 
069193.3%
 
1506.7%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
737
1
 
4
ValueCountFrequency (%) 
073799.5%
 
140.5%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
735
1
 
6
ValueCountFrequency (%) 
073599.2%
 
160.8%
 

Industry_Insurance Carriers
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
678
1
 
63
ValueCountFrequency (%) 
067891.5%
 
1638.5%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
712
1
 
29
ValueCountFrequency (%) 
071296.1%
 
1293.9%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
736
1
 
5
ValueCountFrequency (%) 
073699.3%
 
150.7%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
737
1
 
4
ValueCountFrequency (%) 
073799.5%
 
140.5%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
733
1
 
8
ValueCountFrequency (%) 
073398.9%
 
181.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
737
1
 
4
ValueCountFrequency (%) 
073799.5%
 
140.5%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
739
1
 
2
ValueCountFrequency (%) 
073999.7%
 
120.3%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
740
1
 
1
ValueCountFrequency (%) 
074099.9%
 
110.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
740
1
 
1
ValueCountFrequency (%) 
074099.9%
 
110.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
740
1
 
1
ValueCountFrequency (%) 
074099.9%
 
110.1%
 

Industry_Real Estate
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
733
1
 
8
ValueCountFrequency (%) 
073398.9%
 
181.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
735
1
 
6
ValueCountFrequency (%) 
073599.2%
 
160.8%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
722
1
 
19
ValueCountFrequency (%) 
072297.4%
 
1192.6%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
734
1
 
7
ValueCountFrequency (%) 
073499.1%
 
170.9%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
738
1
 
3
ValueCountFrequency (%) 
073899.6%
 
130.4%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
739
1
 
2
ValueCountFrequency (%) 
073999.7%
 
120.3%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
731
1
 
10
ValueCountFrequency (%) 
073198.7%
 
1101.3%
 

Industry_Stock Exchanges
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
738
1
 
3
ValueCountFrequency (%) 
073899.6%
 
130.4%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
739
1
 
2
ValueCountFrequency (%) 
073999.7%
 
120.3%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
739
1
 
2
ValueCountFrequency (%) 
073999.7%
 
120.3%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
737
1
 
4
ValueCountFrequency (%) 
073799.5%
 
140.5%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
740
1
 
1
ValueCountFrequency (%) 
074099.9%
 
110.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
738
1
 
3
ValueCountFrequency (%) 
073899.6%
 
130.4%
 

Industry_Travel Agencies
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
733
1
 
8
ValueCountFrequency (%) 
073398.9%
 
181.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
740
1
 
1
ValueCountFrequency (%) 
074099.9%
 
110.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
738
1
 
3
ValueCountFrequency (%) 
073899.6%
 
130.4%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
738
1
 
3
ValueCountFrequency (%) 
073899.6%
 
130.4%
 

Sector_Accounting & Legal
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
740
1
 
1
ValueCountFrequency (%) 
074099.9%
 
110.1%
 

Sector_Aerospace & Defense
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
716
1
 
25
ValueCountFrequency (%) 
071696.6%
 
1253.4%
 

Sector_Agriculture & Forestry
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
740
1
 
1
ValueCountFrequency (%) 
074099.9%
 
110.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
737
1
 
4
ValueCountFrequency (%) 
073799.5%
 
140.5%
 

Sector_Biotech & Pharmaceuticals
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
629
1
 
112
ValueCountFrequency (%) 
062984.9%
 
111215.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
644
1
 
97
ValueCountFrequency (%) 
064486.9%
 
19713.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
738
1
 
3
ValueCountFrequency (%) 
073899.6%
 
130.4%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
737
1
 
4
ValueCountFrequency (%) 
073799.5%
 
140.5%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
718
1
 
23
ValueCountFrequency (%) 
071896.9%
 
1233.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
699
1
 
42
ValueCountFrequency (%) 
069994.3%
 
1425.7%
 

Sector_Government
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
730
1
 
11
ValueCountFrequency (%) 
073098.5%
 
1111.5%
 

Sector_Health
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
732
1
 
9
ValueCountFrequency (%) 
073298.8%
 
191.2%
 

Sector_Health Care
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
692
1
 
49
ValueCountFrequency (%) 
069293.4%
 
1496.6%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
561
1
180
ValueCountFrequency (%) 
056175.7%
 
118024.3%
 

Sector_Insurance
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
672
1
 
69
ValueCountFrequency (%) 
067290.7%
 
1699.3%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
707
1
 
34
ValueCountFrequency (%) 
070795.4%
 
1344.6%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
735
1
 
6
ValueCountFrequency (%) 
073599.2%
 
160.8%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
738
1
 
3
ValueCountFrequency (%) 
073899.6%
 
130.4%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
732
1
 
9
ValueCountFrequency (%) 
073298.8%
 
191.2%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
727
1
 
14
ValueCountFrequency (%) 
072798.1%
 
1141.9%
 

Sector_Real Estate
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
733
1
 
8
ValueCountFrequency (%) 
073398.9%
 
181.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
726
1
 
15
ValueCountFrequency (%) 
072698.0%
 
1152.0%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
735
1
 
6
ValueCountFrequency (%) 
073599.2%
 
160.8%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
733
1
 
8
ValueCountFrequency (%) 
073398.9%
 
181.1%
 

Sector_Travel & Tourism
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
733
1
 
8
ValueCountFrequency (%) 
073398.9%
 
181.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
681
1
 
60
ValueCountFrequency (%) 
068191.9%
 
1608.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
733
1
 
8
ValueCountFrequency (%) 
073398.9%
 
181.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
709
1
 
32
ValueCountFrequency (%) 
070995.7%
 
1324.3%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
617
1
124
ValueCountFrequency (%) 
061783.3%
 
112416.7%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
650
1
 
91
ValueCountFrequency (%) 
065087.7%
 
19112.3%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
702
1
 
39
ValueCountFrequency (%) 
070294.7%
 
1395.3%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
701
1
 
40
ValueCountFrequency (%) 
070194.6%
 
1405.4%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
722
1
 
19
ValueCountFrequency (%) 
072297.4%
 
1192.6%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
723
1
 
18
ValueCountFrequency (%) 
072397.6%
 
1182.4%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
695
1
 
46
ValueCountFrequency (%) 
069593.8%
 
1466.2%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
684
1
 
57
ValueCountFrequency (%) 
068492.3%
 
1577.7%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
737
1
 
4
ValueCountFrequency (%) 
073799.5%
 
140.5%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
538
1
203
ValueCountFrequency (%) 
053872.6%
 
120327.4%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
733
1
 
8
ValueCountFrequency (%) 
073398.9%
 
181.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
732
1
 
9
ValueCountFrequency (%) 
073298.8%
 
191.2%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
589
1
152
ValueCountFrequency (%) 
058979.5%
 
115220.5%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
730
1
 
11
ValueCountFrequency (%) 
073098.5%
 
1111.5%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
736
1
 
5
ValueCountFrequency (%) 
073699.3%
 
150.7%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
730
1
 
11
ValueCountFrequency (%) 
073098.5%
 
1111.5%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
735
1
 
6
ValueCountFrequency (%) 
073599.2%
 
160.8%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
725
1
 
16
ValueCountFrequency (%) 
072597.8%
 
1162.2%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
735
1
 
6
ValueCountFrequency (%) 
073599.2%
 
160.8%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
736
1
 
5
ValueCountFrequency (%) 
073699.3%
 
150.7%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
739
1
 
2
ValueCountFrequency (%) 
073999.7%
 
120.3%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
701
1
 
40
ValueCountFrequency (%) 
070194.6%
 
1405.4%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
731
1
 
10
ValueCountFrequency (%) 
073198.7%
 
1101.3%
 

job_state_KS
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
738
1
 
3
ValueCountFrequency (%) 
073899.6%
 
130.4%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
735
1
 
6
ValueCountFrequency (%) 
073599.2%
 
160.8%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
737
1
 
4
ValueCountFrequency (%) 
073799.5%
 
140.5%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
639
1
 
102
ValueCountFrequency (%) 
063986.2%
 
110213.8%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
706
1
 
35
ValueCountFrequency (%) 
070695.3%
 
1354.7%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
735
1
 
6
ValueCountFrequency (%) 
073599.2%
 
160.8%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
739
1
 
2
ValueCountFrequency (%) 
073999.7%
 
120.3%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
732
1
 
9
ValueCountFrequency (%) 
073298.8%
 
191.2%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
720
1
 
21
ValueCountFrequency (%) 
072097.2%
 
1212.8%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
737
1
 
4
ValueCountFrequency (%) 
073799.5%
 
140.5%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
724
1
 
17
ValueCountFrequency (%) 
072497.7%
 
1172.3%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
738
1
 
3
ValueCountFrequency (%) 
073899.6%
 
130.4%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
669
1
 
72
ValueCountFrequency (%) 
066990.3%
 
1729.7%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
727
1
 
14
ValueCountFrequency (%) 
072798.1%
 
1141.9%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
737
1
 
4
ValueCountFrequency (%) 
073799.5%
 
140.5%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
708
1
 
33
ValueCountFrequency (%) 
070895.5%
 
1334.5%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
740
1
 
1
ValueCountFrequency (%) 
074099.9%
 
110.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
740
1
 
1
ValueCountFrequency (%) 
074099.9%
 
110.1%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
728
1
 
13
ValueCountFrequency (%) 
072898.2%
 
1131.8%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
713
1
 
28
ValueCountFrequency (%) 
071396.2%
 
1283.8%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
731
1
 
10
ValueCountFrequency (%) 
073198.7%
 
1101.3%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
700
1
 
41
ValueCountFrequency (%) 
070094.5%
 
1415.5%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
720
1
 
21
ValueCountFrequency (%) 
072097.2%
 
1212.8%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
731
1
 
10
ValueCountFrequency (%) 
073198.7%
 
1101.3%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
605
1
136
ValueCountFrequency (%) 
060581.6%
 
113618.4%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
732
1
 
9
ValueCountFrequency (%) 
073298.8%
 
191.2%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
587
1
154
ValueCountFrequency (%) 
058779.2%
 
115420.8%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
1
442
0
299
ValueCountFrequency (%) 
144259.6%
 
029940.4%
 

title_A
Boolean

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
636
1
 
105
ValueCountFrequency (%) 
063685.8%
 
110514.2%
 

title_DE
Boolean

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
660
1
 
81
ValueCountFrequency (%) 
066089.1%
 
18110.9%
 

title_DS
Boolean

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
433
1
308
ValueCountFrequency (%) 
043358.4%
 
130841.6%
 

title_mle
Boolean

Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
676
1
 
65
ValueCountFrequency (%) 
067691.2%
 
1658.8%
 
Distinct count2
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size741.0 B
0
559
1
182
ValueCountFrequency (%) 
055975.4%
 
118224.6%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

Sample

First rows

df_indexRatingavg_salaryhourlyemployer_providedsame_stateagepythonsassparkawssqlexcelmatlabdesc_lencompSize_1 to 50 employeesSize_10000+ employeesSize_1001 to 5000 employeesSize_201 to 500 employeesSize_5001 to 10000 employeesSize_501 to 1000 employeesSize_51 to 200 employeesSize_UnknownType of ownership_College / UniversityType of ownership_Company - PrivateType of ownership_Company - PublicType of ownership_GovernmentType of ownership_HospitalType of ownership_Nonprofit OrganizationType of ownership_Other OrganizationType of ownership_School / School DistrictType of ownership_Subsidiary or Business SegmentType of ownership_UnknownIndustry_AccountingIndustry_Advertising & MarketingIndustry_Aerospace & DefenseIndustry_Architectural & Engineering ServicesIndustry_Auctions & GalleriesIndustry_Banks & Credit UnionsIndustry_Beauty & Personal Accessories StoresIndustry_Biotech & PharmaceuticalsIndustry_Brokerage ServicesIndustry_Colleges & UniversitiesIndustry_Computer Hardware & SoftwareIndustry_ConstructionIndustry_ConsultingIndustry_Consumer Product RentalIndustry_Consumer Products ManufacturingIndustry_Department, Clothing, & Shoe StoresIndustry_Education Training ServicesIndustry_EnergyIndustry_Enterprise Software & Network SolutionsIndustry_Farm Support ServicesIndustry_Federal AgenciesIndustry_Financial Analytics & ResearchIndustry_Financial Transaction ProcessingIndustry_Food & Beverage ManufacturingIndustry_GamblingIndustry_Gas StationsIndustry_HealthIndustry_Health Care Products ManufacturingIndustry_Health Care Services & HospitalsIndustry_Health, Beauty, & FitnessIndustry_IT ServicesIndustry_Industrial ManufacturingIndustry_Insurance Agencies & BrokeragesIndustry_Insurance CarriersIndustry_InternetIndustry_Investment Banking & Asset ManagementIndustry_K-12 EducationIndustry_LendingIndustry_Logistics & Supply ChainIndustry_Metals BrokersIndustry_MiningIndustry_Motion Picture Production & DistributionIndustry_Other Retail StoresIndustry_Real EstateIndustry_Religious OrganizationsIndustry_Research & DevelopmentIndustry_Security ServicesIndustry_Social AssistanceIndustry_Sporting Goods StoresIndustry_Staffing & OutsourcingIndustry_Stock ExchangesIndustry_TV Broadcast & Cable NetworksIndustry_Telecommunications ManufacturingIndustry_Telecommunications ServicesIndustry_Transportation Equipment ManufacturingIndustry_Transportation ManagementIndustry_Travel AgenciesIndustry_TruckingIndustry_Video GamesIndustry_WholesaleSector_Accounting & LegalSector_Aerospace & DefenseSector_Agriculture & ForestrySector_Arts, Entertainment & RecreationSector_Biotech & PharmaceuticalsSector_Business ServicesSector_Construction, Repair & MaintenanceSector_Consumer ServicesSector_EducationSector_FinanceSector_GovernmentSector_HealthSector_Health CareSector_Information TechnologySector_InsuranceSector_ManufacturingSector_MediaSector_Mining & MetalsSector_Non-ProfitSector_Oil, Gas, Energy & UtilitiesSector_Real EstateSector_RetailSector_TelecommunicationsSector_Transportation & LogisticsSector_Travel & TourismRevenue_$1 to $2 billion (USD)Revenue_$1 to $5 million (USD)Revenue_$10 to $25 million (USD)Revenue_$10+ billion (USD)Revenue_$100 to $500 million (USD)Revenue_$2 to $5 billion (USD)Revenue_$25 to $50 million (USD)Revenue_$5 to $10 billion (USD)Revenue_$5 to $10 million (USD)Revenue_$50 to $100 million (USD)Revenue_$500 million to $1 billion (USD)Revenue_Less than $1 million (USD)Revenue_Unknown / Non-Applicablejob_state_ALjob_state_AZjob_state_CAjob_state_COjob_state_CTjob_state_DCjob_state_DEjob_state_FLjob_state_GAjob_state_IAjob_state_IDjob_state_ILjob_state_INjob_state_KSjob_state_KYjob_state_LAjob_state_MAjob_state_MDjob_state_MIjob_state_MNjob_state_MOjob_state_NCjob_state_NEjob_state_NJjob_state_NMjob_state_NYjob_state_OHjob_state_ORjob_state_PAjob_state_RIjob_state_SCjob_state_TNjob_state_TXjob_state_UTjob_state_VAjob_state_WAjob_state_WIlevel_higherlevel_juniorlevel_otherlevel_seniortitle_Atitle_DEtitle_DStitle_mletitle_other
003.872.000047.0110001125550000001000100000000001000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000010000000000000000000000000001000000000000001000100
113.487.500036.0100000048280010000000000001000000000000000000000000000000010000000000000000000000000000000000000000000100000000000000000100000000000000000000000010000000000000000000100000100
224.885.000110.0111011034950000001000100000000000000000000000000000000000000000000000000000010000000000000000001000000000000000000000001000000000000000100000000000000000000000000000100000100
333.876.500155.0100000039263001000000001000000000000000000000001000000000000000000000000000000000000000000000000000000000000010000000000000001000000000000000000000000000000000000010100000010
442.9114.500122.0110011027483000000100100000000010000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000010000000000000000000000000100000000000000100100
553.495.000120.0100111037833000100000010000000000000000000000000000000000000000000000000010000000000000000000000000000000000001000010000000000000000000000000000000000000000000010000001000100
664.173.500112.0000001018080000001000100000000000001000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000010000000000000000010000000000000000000000100100
773.8114.000015.0101111038470000100000100000000000000000000100000000000000000000000000000000000000000000000000001000000000000000000000000010000000010000000000000000000000000000000000000100100
883.361.00016.0000000015610010000000000100000000000000000000000000000000010000000000000000000000000000000000000000000100000000000000000000001000000000000000000000000000100000000000100000001
994.6140.000111.0101000046092000000100100000000000000000000000000000000000000000010000000000000000000000000000000000000010000000000000001000000000000000000000000000000000100000000000000100010

Last rows

df_indexRatingavg_salaryhourlyemployer_providedsame_stateagepythonsassparkawssqlexcelmatlabdesc_lencompSize_1 to 50 employeesSize_10000+ employeesSize_1001 to 5000 employeesSize_201 to 500 employeesSize_5001 to 10000 employeesSize_501 to 1000 employeesSize_51 to 200 employeesSize_UnknownType of ownership_College / UniversityType of ownership_Company - PrivateType of ownership_Company - PublicType of ownership_GovernmentType of ownership_HospitalType of ownership_Nonprofit OrganizationType of ownership_Other OrganizationType of ownership_School / School DistrictType of ownership_Subsidiary or Business SegmentType of ownership_UnknownIndustry_AccountingIndustry_Advertising & MarketingIndustry_Aerospace & DefenseIndustry_Architectural & Engineering ServicesIndustry_Auctions & GalleriesIndustry_Banks & Credit UnionsIndustry_Beauty & Personal Accessories StoresIndustry_Biotech & PharmaceuticalsIndustry_Brokerage ServicesIndustry_Colleges & UniversitiesIndustry_Computer Hardware & SoftwareIndustry_ConstructionIndustry_ConsultingIndustry_Consumer Product RentalIndustry_Consumer Products ManufacturingIndustry_Department, Clothing, & Shoe StoresIndustry_Education Training ServicesIndustry_EnergyIndustry_Enterprise Software & Network SolutionsIndustry_Farm Support ServicesIndustry_Federal AgenciesIndustry_Financial Analytics & ResearchIndustry_Financial Transaction ProcessingIndustry_Food & Beverage ManufacturingIndustry_GamblingIndustry_Gas StationsIndustry_HealthIndustry_Health Care Products ManufacturingIndustry_Health Care Services & HospitalsIndustry_Health, Beauty, & FitnessIndustry_IT ServicesIndustry_Industrial ManufacturingIndustry_Insurance Agencies & BrokeragesIndustry_Insurance CarriersIndustry_InternetIndustry_Investment Banking & Asset ManagementIndustry_K-12 EducationIndustry_LendingIndustry_Logistics & Supply ChainIndustry_Metals BrokersIndustry_MiningIndustry_Motion Picture Production & DistributionIndustry_Other Retail StoresIndustry_Real EstateIndustry_Religious OrganizationsIndustry_Research & DevelopmentIndustry_Security ServicesIndustry_Social AssistanceIndustry_Sporting Goods StoresIndustry_Staffing & OutsourcingIndustry_Stock ExchangesIndustry_TV Broadcast & Cable NetworksIndustry_Telecommunications ManufacturingIndustry_Telecommunications ServicesIndustry_Transportation Equipment ManufacturingIndustry_Transportation ManagementIndustry_Travel AgenciesIndustry_TruckingIndustry_Video GamesIndustry_WholesaleSector_Accounting & LegalSector_Aerospace & DefenseSector_Agriculture & ForestrySector_Arts, Entertainment & RecreationSector_Biotech & PharmaceuticalsSector_Business ServicesSector_Construction, Repair & MaintenanceSector_Consumer ServicesSector_EducationSector_FinanceSector_GovernmentSector_HealthSector_Health CareSector_Information TechnologySector_InsuranceSector_ManufacturingSector_MediaSector_Mining & MetalsSector_Non-ProfitSector_Oil, Gas, Energy & UtilitiesSector_Real EstateSector_RetailSector_TelecommunicationsSector_Transportation & LogisticsSector_Travel & TourismRevenue_$1 to $2 billion (USD)Revenue_$1 to $5 million (USD)Revenue_$10 to $25 million (USD)Revenue_$10+ billion (USD)Revenue_$100 to $500 million (USD)Revenue_$2 to $5 billion (USD)Revenue_$25 to $50 million (USD)Revenue_$5 to $10 billion (USD)Revenue_$5 to $10 million (USD)Revenue_$50 to $100 million (USD)Revenue_$500 million to $1 billion (USD)Revenue_Less than $1 million (USD)Revenue_Unknown / Non-Applicablejob_state_ALjob_state_AZjob_state_CAjob_state_COjob_state_CTjob_state_DCjob_state_DEjob_state_FLjob_state_GAjob_state_IAjob_state_IDjob_state_ILjob_state_INjob_state_KSjob_state_KYjob_state_LAjob_state_MAjob_state_MDjob_state_MIjob_state_MNjob_state_MOjob_state_NCjob_state_NEjob_state_NJjob_state_NMjob_state_NYjob_state_OHjob_state_ORjob_state_PAjob_state_RIjob_state_SCjob_state_TNjob_state_TXjob_state_UTjob_state_VAjob_state_WAjob_state_WIlevel_higherlevel_juniorlevel_otherlevel_seniortitle_Atitle_DEtitle_DStitle_mletitle_other
7317324.1111.000113.00000100101035260100000000100000000000000000000000000000000000000000000100000000000000000000000000000001000000000000000000000000000010010000000000000000000000000000000000000100010
7327333.9138.500112.00000100010057770000000100010000000000000000010000000000000000000000000000000000000000000000000000000000000010000000000000000000000010010000000000000000000000000000000000000110000
7337343.668.5000169.00000000001050710000010000100000000000000000000000000000000000000000100000000000000000000000000000000000000001000000000000010000000000000000000000000100000000000000000000000100100
7347353.987.50019.00000100111038492000100000100000000000000000000000000000000000000000010000000000000000000000000000000000000010000000000000001000000000010000000000000000000000000000000000100001000
7357363.6111.50003.00000000000050643010000000010000000000000010000000000000000000000000000000000000000000000000000000010000000000000000000000000100000000000000000000000000000000000100000000000100100
7367373.984.5000190.00000000100062193010000000010000000000000010000000000000000000000000000000000000000000000000000000010000000000000000000000010000000000000000000000000100000000000000000000000100001
7377384.4102.500014.00000101110061673001000000010000000000000000000000000000000000000000010000000000000000000000000000000000000010000000000000001000000000000000000000000000000000000000100000000101000
7387392.673.500136.00000000001031070000001001000000000000000000100000000000000000000000000000000000000000000000000000000001000000000000000000000000000010000000000000000000000000000100000000100000010
7397403.2127.500046.65587000001016780100000000100000000000000000000000000000000000000000000000000000000010000000000000001000000000000000000000000000100000000000000000000000000000000100000000000100100
7407413.693.500053.00000100000037100000001000000010000000000000000000000001000000000000000000000000000000000000000000000000010000000000000000000000010000000000000000000000000000010000000000100000010